﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_Pack') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_Pack
END
GO
create view V_Pack
as select 
A.[Guid]
,A.[Cost]
,A.[FreeLimit]
from [ShopNum1_Pack] A where A.IsDeleted=0